﻿using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using FrameWork.Entity;
using Microsoft.ApplicationBlocks.Data;
using System.Data.SqlClient;

namespace FrameWork.web.Code
{
    public class its_FieldValueCs
    {

        public its_FieldValueCs()
        {
            Microsoft.ApplicationBlocks.Data.SqlHelper.connectionString = ConfigurationManager.AppSettings["MsSql"].ToString();
        }
        /// <summary>
        /// 查找
        /// </summary>
        /// <param name="_sys_FieldValue"></param>
        /// <returns></returns>

        public DataTable Field_SelectInfoByF_Key(sys_FieldValue _sys_FieldValue)
        {
            SqlParameter[] sp = new SqlParameter[1]{
				new SqlParameter("@V_F_Key",SqlDbType.VarChar),
			
			};
            //

            sp[0].Value = _sys_FieldValue.V_F_Key;
            sp[0].Direction = ParameterDirection.Input;


            try
            {
                DataSet ds = new DataSet();
                ds = SqlHelper.ExecuteDataset(CommandType.StoredProcedure, "dbo.its_FieldValue_SelectInfoByV_F_Key", sp);
                DataTable dt = ds.Tables[0];
                return dt;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }


    }
}
